package com.huangsiyuan.myepidemic.mapper;

import com.huangsiyuan.myepidemic.beans.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserMapper {
    @Select(value = "SELECT u.`user_id`,u.`account`,u.`password`,u.`user_name` " +
            "FROM users u " +
            "WHERE u.`account`=#{account} " +
            "AND u.`del_flag` IS NULL OR u.`del_flag`=0")
    UserInfo findByAccount(String account);
}
